package cn.swust.designpatternlearningplatform.dao.sql;

import org.apache.ibatis.jdbc.SQL;

public class TeacherDaoSql {
    //获取教师的密码
    public String getTeacherPassword(String  number){
        return new SQL(){
            {
                SELECT("teacher_password");
                FROM("teacher");
                WHERE("teacher_account=#{number}");
            }
        }.toString();
    }
    //通过学号获取教师的基本信息
    public String getTeacherByNumber(String number){
        return new SQL(){
            {
                SELECT("*");
                FROM("teacher");
                WHERE("teacher_account=#{number}");
            }
        }.toString();
    }


}
